HI I am trying to creat a dynamic collections in sccm 2007, I am very confused wehen i writing the query in new collection wizard, i have created queries in sql when past this query in the query design in collection its not working and throwing erros and same will happen for existing collection in sql (if i use the all systems qury in sql ). pleasesuggest me or explain me how i can effectivle create custome collections to meet my requirements Satya